forum

home / developersection / forums / sql queries cleaner better in jquery

Ask Question

SQL queries cleaner better in jquery

Manoj Bhatt 2111 06-Nov-2014

I have something like this:

SELECT cars.brand, cars.id FROM cars WHERE cars.brand = 4 LIMIT 1;
SELECT cars.brand, cars.id FROM cars WHERE cars.brand = 24 LIMIT 1;
SELECT cars.brand, cars.id FROM cars WHERE cars.brand = 29 LIMIT 1;

If will be more queries it will be very long. How do this in the other way, in one line? But important is for me speed. cars.brand = X AND LIMIT X is a variable so it maybe changes.

mssql server mysql  sql server  sql 
Updated on 06-Nov-2014
Manoj Bhatt

Other

Follow
Can you answer this question?
Answer

1 Answers

Anonymous User

Anonymous User

06-Nov-2014

You are worried about having to send so many queries one by  one, so that would take a lot of time. You can make this one query instead:

SELECT cars.brand, cars.id FROM cars WHERE cars.brand = 4 LIMIT 1
UNION ALL
SELECT cars.brand, cars.id FROM cars WHERE cars.brand = 24 LIMIT 1
UNION ALL
SELECT cars.brand, cars.id FROM cars WHERE cars.brand = 29 LIMIT 1;
MindStick Training
MindStick Training

Liked By

We use cookies to ensure you have the best browsing experience on our website. By using our site, you acknowledge that you have read and understood our Cookie Policy & Privacy Policy